const fs = require('fs')
const { Sequelize } = require('../service/base')
const config = require(__dirname + '../config').db
const { database, username, password } = config
const _ = require('lodash')
const path = require('path')
const sequelize = new Sequelize(database, username, password, _.pick(config, ['port', 'dialect', 'host']))
const db = {}
const basename = path.basename(__filename)

fs.readdirSync(__dirname)
  .filter(file => {
    return (file.indexOf('.') !== 0) && (file !== basename) && (file.slice(-3) === '.js')
  })
  .forEach(file => {
    const model = sequelize['import'](path.join(__dirname, file))
    db[model.name] = model

  })

Object.keys(db).forEach(modelName => {
  if (db[modelName].associate) {
    db[modelName].associate(db)
  }
})

db.sequelize = sequelize
db.Sequelize = Sequelize

module.exports = db